select fname as ,lname as" ϐ",mobile as " "
from Person
-------------------------------------------------------------------------------------
select fname as   , LName as ' ϐ'
from person
-------------------------------------------------------------------------------------
select JBID , EMID , ADID , STID
from Student ,Employer , Adviser , Job
-------------------------------------------------------------------------------------
UPDATE PersonRepeat SEt Married=1 where PSID>1004
-------------------------------------------------------------------------------------
select *
from Person
where BPalse = '' or Street = ''
-------------------------------------------------------------------------------------
select FName , NationID from Person
where Person.NationID = some (select NationID from Adviser)
-------------------------------------------------------------------------------------
select person.FName , Student.SchoolName 
from Student , person
where person.NationID = Student.NationID
	  and LastAverage > 16
-------------------------------------------------------------------------------------
exec Student_Average_Up @Average_Num = 15
-------------------------------------------------------------------------------------
select distinct  person.FName +' '+Person.LName 
from Preform , Adviser , Person 
where adviser.NationID = person.NationID 
      and Preform.Commander1=person.FName +' '+Person.LName 	
-------------------------------------------------------------------------------------
select distinct  person.FName +' '+Person.LName 
	from Preform , Adviser , Person ,Job
	where adviser.NationID = person.NationID 
	and Preform.Commander1=person.FName +' '+Person.LName
	and  job.JBID =1412
-------------------------------------------------------------------------------------
exec Adviser_Name_Job @ADNPJ = 1412
-------------------------------------------------------------------------------------
select FName , LName  , Age = 1391- year(BurnDate) 
from Person
where Job = '' and sex = 0
order by Age  
-------------------------------------------------------------------------------------
select FName,LName,Education  
from Person,Adviser
where RegionCity = ''
and Adviser.NationID = Person.NationID
-------------------------------------------------------------------------------------
use AyeneyZohor
insert into dbo.PersonRepeat
(LifeLevel,Regilion,Creed,RegilionCommander,City,Sex,Married)
output inserted.PSID
values('','' , '' , 'ǁ ' , ' ʐ' , 'False' , 'False')
-------------------------------------------------------------------------------------
use AyeneyZohor
delete from dbo.PersonRepeat
where PSID = 1034
-------------------------------------------------------------------------------------
use AyeneyZohor
delete from dbo.PersonRepeat
where PSID in (1032 , 1033) 
-------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------	
	
	
	
*********************************************************************************


      afa        afa afaafa       afa  
  afa     afa    afa          afa     afa
  afa afa afa    afaafa       afa afa afa
  afa     afa    afa          afa     afa


